{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ポジションサイズの計算","獲得金額の計算","利益計算"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ポジションサイズの計算","index":0,"n_rows":19,"n_cols":20,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,17,3,19],[0,1,0,6],[3,1,3,5],[3,6,3,10],[3,11,3,13],[3,14,3,16]]}
[null,"EUR/CAD　日足　2009年12月～2012年1月"]
[]
[]
[null,"エントリー前",null,null,null,null,"決済後",null,null,null,null,"損益pips",null,null,"損切り幅の計算"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M",1,2,3,null,"エントリー","決済"]
["No","資金","ロスカット","損切り幅","レート","ﾎﾟｼﾞｼｮﾝｻｲｽﾞ","獲得pips","ロット",null,"レート","損益","エントリー","決済","損益","STOP","エントリー","損切り幅","売買","日付","日付"]
[]
[1,500000,0.03,163,96,{"$f":"SUM(B8*C8/D8/E8)","v":0.95858895705521474},1075,0.9,100,0.96,{"$f":"SUM(G8*H8*I8*J8)","v":92880},1.5457000000000001,1.4381999999999999,{"$f":"SUM(L8-M8)","v":0.10750000000000015},1.5620000000000001,1.5457000000000001,{"$f":"SUM(O8-P8)","v":1.6299999999999981E-2},"売","2015-12-15","2015-02-25"]
[2,{"$f":"SUM(B8+K8)","v":592880},0.03,129,96,{"$f":"SUM(B9*C9/D9/E9)","v":1.4362403100775192},1311,1.4,100,0.96,{"$f":"SUM(G9*H9*I9*J9)","v":176198.39999999999},1.3969,1.2658,{"$f":"SUM(L9-M9)","v":0.13109999999999999},1.4097999999999999,1.3969,{"$f":"SUM(O9-P9)","v":1.2899999999999912E-2},"売","2015-03-15","2015-05-19"]
[3,769078.4,0.03,122,96,1.9699754098360653,738,1.9,100,0.96,134611.19999999998,1.2635000000000001,1.3372999999999999,{"$f":"SUM(M10-L10)","v":7.3799999999999866E-2},1.2513000000000001,1.2635000000000001,{"$f":"SUM(P10-O10)","v":1.2199999999999989E-2},"買","2015-06-23","2015-07-02"]
[4,903689.6,0.03,115,96,2.4556782608695653,632,2.4,100,0.96,145612.79999999999,1.3887,1.3254999999999999,{"$f":"SUM(L11-M11)","v":6.3200000000000145E-2},1.4001999999999999,1.3887,{"$f":"SUM(O11-P11)","v":1.1499999999999844E-2},"売","2015-11-22","2015-12-03"]
[5,1049302.3999999999,0.03,133,96,2.4654661654135337,423,2.4,100,0.96,97459.199999999997,1.3223,1.28,{"$f":"SUM(L12-M12)","v":4.2300000000000004E-2},1.3355999999999999,1.3223,{"$f":"SUM(O12-P12)","v":1.3299999999999867E-2},"売","2015-01-05","2015-01-10"]
[6,1146761.5999999999,0.03,110,96,3.2578454545454547,456,3.2,100,0.96,140083.19999999998,1.35,1.3956,4.5599999999999863E-2,1.339,1.35,{"$f":"SUM(P13-O13)","v":1.1000000000000121E-2},"買","2015-03-11","2015-03-21"]
[7,1286844.7999999998,0.03,106,96,3.7937641509433955,345,3.7,100,0.96,122544,1.3951,1.4296,3.4499999999999975E-2,1.3845000000000001,1.3951,{"$f":"SUM(P14-O14)","v":1.0599999999999943E-2},"買","2015-04-27","2015-05-05"]
[8,1409388.7999999998,0.03,64,96,{"$f":"SUM(B15*C15/D15/E15)","v":6.8817812499999986},553,6.8,100,0.96,360998.39999999997,1.3782000000000001,1.4335,5.5299999999999905E-2,1.3717999999999999,1.3782000000000001,{"$f":"SUM(P15-O15)","v":6.4000000000001833E-3},"買","2015-05-25","2015-06-06"]
[9,1770387.1999999997,0.03,90,96,6.1471777777777765,634,6.1,100,0.96,371270.39999999991,1.4068000000000001,1.3433999999999999,{"$f":"SUM(L16-M16)","v":6.3400000000000123E-2},1.4157999999999999,1.4068000000000001,{"$f":"SUM(O16-P16)","v":8.999999999999897E-3},"売","2015-06-29","2015-07-20"]
[10,2141657.5999999996,0.03,99,96,6.7602828282828265,361,6.7,100,0.96,232195.20000000001,1.3843000000000001,1.3482000000000001,{"$f":"SUM(L17-M17)","v":3.6100000000000021E-2},1.3942000000000001,1.3843000000000001,{"$f":"SUM(O17-P17)","v":9.9000000000000199E-3},"売","2015-09-08","2015-09-14"]
[11,2373852.7999999998,0.03,125,96,5.9346319999999997,-72,5.9,100,0.96,-40780.799999999996,1.3905000000000001,1.3976999999999999,{"$f":"SUM(L18-M18)","v":-7.1999999999998732E-3},1.403,1.3905000000000001,{"$f":"SUM(O18-P18)","v":1.2499999999999956E-2},"売","2015-11-09","2015-11-21"]
[12,2333072,0.03,100,96,7.2908499999999998,710,7.2,100,0.96,490752,1.36,1.2889999999999999,{"$f":"SUM(L19-M19)","v":7.1000000000000174E-2},1.37,1.36,{"$f":"SUM(O19-P19)","v":1.0000000000000009E-2},"売","2015-12-12","2015-01-17"]

{"sheet":"獲得金額の計算","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["獲得pips","数量",null,"レート","獲得金額円"]
[411,1.3,100,0.96,{"$f":"SUM(A4*B4*C4*D4)","v":51292.800000000003}]
[422,1.2,100,0.96,48614.400000000001]
[77,1,100,0.96,7392]
[2787,0.6,100,0.96,160531.19999999998]
[289.2,1.1000000000000001,100,0.96,30539.52]
[220.8,0.8,100,0.96,16957.439999999999]
[745,2.6,100,0.96,185952]
[213,0.5,100,0.96,10224]
[304,1.8,100,0.96,52531.200000000004]
[566,0.5,100,0.96,27168]
[306,3,100,0.96,88128]
[772,0.5,100,0.96,37056]
[1551,0.5,100,0.96,74448]
[]
[null,null,null,null,{"$f":"SUM(E4:E16)","v":790834.56}]
[]
[]
[]
[]
[402,1.5,100,null,{"$f":"SUM(A23*B23*C23)","v":60300}]
[221,1.5,100,null,{"$f":"SUM(A24*B24*C24)","v":33150}]
[882,1.3,100,null,114660.00000000001]
[493,0.6,100,null,29580]
[669,1,100,null,66900]
[169,5,100,null,84500]
[115,6.2,100,null,71300]

{"sheet":"利益計算","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"エントリー","決済","損益","獲得pips",null,"STOP","エントリー","損切り"]
[1]
[2,1.3886000000000001,1.3474999999999999,{"$f":"SUM(B4-C4)","v":4.1100000000000136E-2},{"$f":"SUM(D4*10000)","v":411.00000000000136}]
[3,1.3227,1.2805,{"$f":"SUM(B5-C5)","v":4.2200000000000015E-2},422]
[4,1.3184800000000001,1.3107800000000001,{"$f":"SUM(B6-C6)","v":7.7000000000000401E-3},77]
[5,1.5447,1.266,{"$f":"SUM(B7-C7)","v":0.27869999999999995},2787,null,1.57,1.5447,{"$f":"SUM(G7-H7)","v":2.53000000000001E-2}]
[6,1.3687,1.3976200000000001,{"$f":"SUM(C8-B8)","v":2.8920000000000057E-2},289.2,"買い",1.355,1.3687,{"$f":"SUM(H8-G8)","v":1.3700000000000045E-2}]
[7,1.3893,1.3672200000000001,{"$f":"SUM(B9-C9)","v":2.2079999999999878E-2},220.8,null,1.4068000000000001,1.3893,{"$f":"SUM(G9-H9)","v":1.7500000000000071E-2}]
[8,121.61,125.63,{"$f":"SUM(C10-B10)","v":4.019999999999996},402,"買い",120.64,121.61,{"$f":"SUM(H10-G10)","v":0.96999999999999886},"買い"]
[9,122.79,120.58,2.210000000000008,221,null,123.74,122.79,{"$f":"SUM(G11-H11)","v":0.94999999999998863}]
[10,1.5447,1.266,0.27869999999999995,2787,null,1.2158,1.2441,{"$f":"SUM(H12-G12)","v":2.8299999999999992E-2},"買い"]
[null,1.2228000000000001,1.2441,{"$f":"SUM(C13-B13)","v":2.1299999999999875E-2},213,"買い",1.2410000000000001,1.2494000000000001,{"$f":"SUM(H13-G13)","v":8.3999999999999631E-3},"買い"]
[null,1.2490000000000001,1.2794000000000001,{"$f":"SUM(C14-B14)","v":3.0399999999999983E-2},304,"買い",1.2643,1.2694000000000001,{"$f":"SUM(H14-G14)","v":5.1000000000001044E-3},"買い"]
[null,1.2228000000000001,1.2794000000000001,{"$f":"SUM(C15-B15)","v":5.6599999999999984E-2},566,"買い",186.95,185.82,{"$f":"SUM(H15-G15)","v":-1.1299999999999955}]
[null,1.2694000000000001,1.3,{"$f":"SUM(C16-B16)","v":3.0599999999999961E-2},306,"買い",121.73,121.49,{"$f":"SUM(H16-G16)","v":-0.24000000000000909}]
[null,1.2228000000000001,1.3,{"$f":"SUM(C17-B17)","v":7.7199999999999935E-2},772,"買い"]
[null,185.82,177,{"$f":"SUM(B18-C18)","v":8.8199999999999932},882,"売り"]
[null,179.87,184.8,{"$f":"SUM(B19-C19)","v":-4.9300000000000068},493,"買い"]
[null,182.45,175.76,{"$f":"SUM(B20-C20)","v":6.6899999999999977},669,"売り"]